JANUARY DE 2023 GRADE BOOK UPDATED


1	95166	Barrow, Harlee	18	90	A	2022/02/22 12:18 PM	77.8	A	2022/02/16 8:09 AM		33	100	A	2022/02/08 4:46 PM
2	64473	Biddix, Addison	19	95	A	2022/02/22 12:20 PM	13	72.2	A	2022/02/16 8:10 AM	28	84.8	A	2022/02/08 4:38 PM
3	46014	Burk, Zephania	20	100	A	2022/02/22 12:19 PM	18	100	A	2022/02/16 8:09 AM	32	97	A	2022/02/08 4:42 PM
4	15364	Culberson, Riley	17	85	A	2022/02/22 12:19 PM	14	77.8	A	2022/02/16 8:07 AM	27	81.8	A	2022/02/08 4:40 PM
5	45784	Engelhardt, Lily	19	95	A	2022/02/22 12:20 PM	17	94.4	A	2022/02/16 8:07 AM	22	66.7	A	2022/02/08 4:43 PM
6	15106	Felix, Shawn	9	45	A	2022/02/22 12:20 PM	9	50	A	2022/02/16 8:06 AM	12	36.4	A	2022/02/08 4:40 PM
7	19075	Gahimer, Tritten	17	85	A	2022/02/22 12:19 PM	12	66.7	A	2022/02/16 8:08 AM	25	75.8	A	2022/02/08 4:47 PM
8	25243	Getten, Ali	19	95	A	2022/02/22 12:19 PM	17	94.4	A	2022/02/16 8:08 AM	30	90.9	A	2022/02/08 4:45 PM
9	51375	Haffner, Ricardo	16	80	A	2022/02/22 12:18 PM	15	83.3	A	2022/02/16 8:09 AM	30	90.9	A	2022/02/08 4:39 PM
10	49855	Hoffman, Mason	19	95	A	2022/02/22 12:19 PM	15	83.3	A	2022/02/16 8:08 AM	28	84.8	A	2022/02/08 4:37 PM
11	13323	Kadner, Claire	16	80	A	2022/02/22 12:19 PM	15	83.3	A	2022/02/16 8:08 AM	29	87.9	A	2022/02/08 4:43 PM
12	86756	Keller, Kyle	20	100	A	2022/02/22 12:18 PM	14	77.8	A	2022/02/16 8:08 AM	25	75.8	A	2022/02/08 4:44 PM
13	11175	Marceau, Mona	15	75	A	2022/02/22 12:26 PM	15	83.3	A	2022/02/16 8:09 AM	27	81.8	A	2022/02/08 4:47 PM
14	12908	McCluey, Jake	16	80	A	2022/02/22 12:20 PM	13	72.2	A	2022/02/16 8:07 AM	18	54.5	A	2022/02/08 4:41 PM
15	95016	Mehan, Bryce	17	85	A	2022/02/22 12:18 PM	16	88.9	A	2022/02/16 8:07 AM	28	84.8	A	2022/02/08 4:36 PM
16	21925	Nieto, Jeremy	16	80	A	2022/02/22 12:18 PM	14	77.8	A	2022/02/16 8:09 AM	27	81.8	A	2022/02/08 4:37 PM
17	77197	Pemberton, Graycie	14	70	A	2022/02/22 12:19 PM	16	88.9	A	2022/02/16 8:09 AM	29	87.9	A	2022/02/08 4:46 PM
18	54774	Pigman, LorAnn	19	95	A	2022/02/22 12:20 PM	15	83.3	A	2022/02/16 8:09 AM	29	87.9	A	2022/02/08 4:45 PM
19	91703	Polacek, Carson	19	95	A	2022/02/22 12:19 PM	17	94.4	A	2022/02/16 8:07 AM	25	75.8	A	2022/02/08 4:42 PM
20	82062	Roullier, Cameron	17	85	A	2022/02/22 12:20 PM	15	83.3	A	2022/02/16 8:07 AM	29	87.9	A	2022/02/08 4:41 PM
21	32364	Stewart, Steven	19	95	A	2022/02/22 12:19 PM	12	66.7	A	2022/02/16 8:08 AM	27	81.8	A	2022/02/08 4:35 PM
22	24557	Vitale, Thomas	19	95	A	2022/02/22 12:18 PM	16	88.9	A	2022/02/16 8:10 AM	32	97	A	2022/02/08 4:36 PM
23	30068	Zech, Gabriel	18	90	A	2022/02/22 12:19 PM	16	88.9	A	2022/02/16 8:10 AM	31	93.9	A	2022/02/08 4:39 PM
24					30068	Zech, Gabriel	16	88.9	A	2022/02/16 8:06 AM


1	Pick a student from the list in cell B4. The rest of the sheet will automatically update to display their grades & class averages.
2
3	INDIVIDUAL REPORT FOR
4	Student 1
5
6	CLASS NAME		CH 5	CH 6	TELL	CH 11	CH 12	Notes	Final Test	TOTAL POINTS	AVERAGE	AVERAGE
7	#REF!	88%	89%	87%	80%	83%	81%	100%	86%
8	Select a student from the list in cell B4
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27


1					Enter your assignments, quizzes, and tests in Row 2. Assign the total points possible for each one in Row 3. Student grades will automatically be calculated in columns C/D.					You must earn an 80% or higher in the classroom to be considered to be waived.
2					CH 5	CH 6	TELL	CH 11	CH 12	Notes	Final Test	TOTAL POINTS	AVERAGE
3					19	19	33	18	20	100	50	259

5			B	84%	16.8	16.9	28.7	14.4	16.5	80.7	50.0	224.0	86.9
6	1	75064			15	16	30	14	17	70	50	212	82
7	2	76124			18	16	28	16	18	60	50	206	80
8	3	93331			16	17	27	12	16	75	50	213	83
9	4	78230			17	17	28	13	17	80	50	222	86
10	5	11568			13	18	25	15	17	75	50	213	83
11	6	76262			18	17	28	16	16	80	50	225	87
12	7	94055			18	16	30	16	18	90	50	238	92
13	8	11524			17	18	32	17	18	95	50	247	96
14	9	11507			17	18	28	16	18	65	50	212	82
15	10	75077			15	17	29	15	18	95	50	239	93
16	11	74986			19	18	28	16	16	70	50	217	84
17	12	11037			18	18	29	17	18	90	50	240	93
18	14	58967			14	17	28	13	18	100	50	240	93
19	15	78126			18	13	31	15	12	70	50	209	81
20	16	76183			18	19	30	13	16	75	50	221	86
21	17	99409			18	18	29	12	17	90	50	234	91
22	18	60663			14	15	22	13	6	70	50	190	74
23	19	77266			14	18	33	16	18	90	50	239	93
24	20	74849			16	17	26	13	18	90	50	230	89
25	21	75088			17	17	31	13	17	75	50	220	85
26	22	11344			19	17	31	16	16	86	50	235	91
27	23	12057			18	17	29	11	17	75	50	217	84
28	24	16295			19	15	27	14	18	90	50	233	90
29
30
31
32
33
34
35


1	GRADEBOOK
2	OVERVIEW
3	Change the grading system by editing the '% Range' and 'Grade' letters below. The number of students with each grade will be calculated automatically based on the 'Grades' tab. View reports for individual students on the 'Individual report' tab.
4
5	GRADING SYSTEM					GRADE DISTRIBUTION	AVERAGE SCORES
6	% Range			Grade	# of students	based on class avg.	per assignment
8	97	-	100	A+	0
9	93	-	96	A	0
10	90	-	92	A-	0
11	87	-	89	B+	0
12	83	-	86	B	0
13	80	-	82	B-	0
14	77	-	79	C+	0
15	70	-	76	C	0
16	60	-	69	D	0
17	0	-	59	F	0
19